﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace CloudDiamonds.Models.DBModels
{
    public class InlaySettings
    {
        //数据中心对应属性
        public int ID { get; set; } //int (11) NOT NULL AUTO_INCREMENT,
        public DateTime InsertTime { get; set; } //datetime NOT NULL DEFAULT '0000-00-00 00:00:00', 入库时间，不用手动指定
        public DateTime UpdateTime { get; set; } // datetime NOT NULL DEFAULT '0000-00-00 00:00:00', 更新时间，不用手动指定
        public int OnShelves { get; set; } //tinyint(1) NOT NULL DEFAULT '0', 是否上架
        public int Tag { get; set; } //tinyint(1) NOT NULL DEFAULT '0' COMMENT '标签',
        public string Supplier { get; set; } //varchar(50) NOT NULL DEFAULT '', 供应商
        public int Status { get; set; } //tinyint(2) NOT NULL DEFAULT '0' COMMENT '状态',
        public int Material { get; set; } //tinyint(2) NOT NULL DEFAULT '0' COMMENT '材质',
        public string OriginSN { get; set; } //varchar(20) NOT NULL DEFAULT '' COMMENT '货号',
        public string StyleNo { get; set; } //varchar(20) NOT NULL DEFAULT '' COMMENT '款号',
        public string Images { get; set; } // varchar(300) NOT NULL DEFAULT '' COMMENT '图片',
        public string Videos { get; set; } // varchar(300) NOT NULL DEFAULT '' COMMENT '视频',  
        public int Technics { get; set; } //tinyint(2) NOT NULL DEFAULT '0' COMMENT '类别（主石类型）',
        public int Type { get; set; } //tinyint(2) NOT NULL DEFAULT '0' COMMENT '类型（戒指、耳环等）',
        public int Style { get; set; } //tinyint(2) NOT NULL DEFAULT '0' COMMENT '风格',
        public string Series { get; set; } // varchar(20) NOT NULL DEFAULT '' COMMENT '系类名称',
        public int MainShape { get; set; } // tinyint(2) NOT NULL DEFAULT '0' COMMENT '形状',
        public decimal MainWeight { get; set; } //decimal (12,3) NOT NULL DEFAULT '0.000' COMMENT '主石重',
        public decimal SideWeight { get; set; } // decimal (12,3) NOT NULL DEFAULT '0.000' COMMENT '副石重',
        public int SideNum { get; set; } //tinyint(2) NOT NULL DEFAULT '0' COMMENT '副石数量',
        public decimal BuyGoldWeight { get; set; } //decimal (12,3) NOT NULL DEFAULT '0.000' COMMENT '买金重',
        public decimal BuyGoldPrice { get; set; } //decimal (12,3) NOT NULL DEFAULT '0.000' COMMENT '买金价',
        public decimal BuyWastage { get; set; } //decimal (12,3) NOT NULL DEFAULT '0.000' COMMENT '买耗',
        public decimal BuySidePrice { get; set; } //decimal (12,3) NOT NULL DEFAULT '0.000' COMMENT '买副石价',
        public decimal SideLaborFee { get; set; } //decimal (12,3) NOT NULL DEFAULT '0.000' COMMENT '副石工费',
        public decimal BuyLaborFee { get; set; } //decimal (12,3) NOT NULL DEFAULT '0.000' COMMENT '买工费',
        public decimal BuySideLaborFee { get; set; } //decimal(12,3) NOT NULL DEFAULT '0.000' COMMENT '买副石工费',
        public decimal NetGoldWeight { get; set; } // decimal (12,3) NOT NULL DEFAULT '0.000' COMMENT '净金重',
        public decimal SidePrice { get; set; } // decimal (12,3) NOT NULL DEFAULT '0.000' COMMENT '副石总额',
        public decimal TotalWeight { get; set; } // decimal (12,3) NOT NULL DEFAULT '0.000' COMMENT '总重',
        public decimal LaborFee { get; set; } //decimal (12,3) NOT NULL DEFAULT '0.000' COMMENT '工费',
        public decimal Wastage { get; set; } //decimal (12,3) NOT NULL DEFAULT '0.000' COMMENT '损耗',
        public decimal Insurance { get; set; } // decimal (12,3) NOT NULL DEFAULT '0.000' COMMENT '保险费',
        public string Measurement { get; set; } // varchar(30) NOT NULL DEFAULT '' COMMENT '尺寸',
        public string Manufactor { get; set; } //varchar(30) NOT NULL DEFAULT '' COMMENT '厂家',
        public int IsStock { get; set; } //tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否现货',
        public string Country { get; set; } //varchar(20) NOT NULL DEFAULT '' COMMENT '所在地国家',
        public string State { get; set; } //varchar(20) NOT NULL DEFAULT '' COMMENT '所在地省份',
        public string Remark { get; set; } //varchar(100) NOT NULL DEFAULT '' COMMENT '备注',
        public string Details { get; set; } //varchar(100) NOT NULL DEFAULT '' COMMENT '详情（仅库存管理可见，不开放）',

        public decimal GoldPrice { get; set; } //decimal (12,3) NOT NULL DEFAULT '0.000' COMMENT '金价', # 不支持新增和修改，新增、修改请忽略此字段，如需修改使用素金的金价修改接口

        //20180807 新增字段
        public string PurchaseTime { get; set; } //采购日期
        public string PurchaseSupplier { get; set; }//采购供应商
        public decimal? PurchaseUSD { get; set; }   //采购价$
        public decimal? PurchaseRMB { get; set; }  //采购价￥
        public string PurchaseAgent { get; set; }   //采购人
        public int ReceiptStatus { get; set; } //付款状态：0未付 1，已付
        public string ShipTime { get; set; }   //发货时间
        public string ArrivalTime { get; set; }//现货到货日期
        public decimal? PurchaseExchange { get; set; }   //采购汇率

        public decimal Price { get; set; }//回库的时候要去掉
                                          /// <summary>
                                          /// 金价（加）
                                          /// </summary>
        public decimal CustomerGoldPrice { get; set; } = 0;
        /// <summary>
        ///副石工费（加）
        /// </summary>
        public decimal CustomerSideLaborFee { get; set; } = 0;

        /// <summary>
        ///工费（乘）
        /// </summary>
        public decimal CustomerLaborFee { get; set; } = 1;
        /// <summary>
        ///损耗 （加）
        /// </summary>
        public decimal CustomerWastage { get; set; } = 0;

        /// <summary>
        ///副石总额（乘）
        /// </summary>
        public decimal CustomerSidePrice { get; set; } = 1;

        /// <summary>
        ///保险费（乘）
        /// </summary>
        public decimal CustomerInsurance { get; set; } = 1;
    }
}
